USE [DSRSystem_Temp]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[spGetCompanyProfiles]
AS
BEGIN
	SET NOCOUNT ON;

	DECLARE @ChangedSince datetime
	SET @ChangedSince = '2010-01-01'

	DECLARE @FinalizedCompanies TABLE
	(
		[CompanyId] uniqueidentifier NOT NULL,
	    [CompanyName] nvarchar(max) NOT NULL,
		[LastFinalUpdate] datetime NOT NULL,
	    [LastCentralizedResearchUpdate] datetime NOT NULL
	)
	INSERT INTO @FinalizedCompanies
	EXECUTE [DSRSystem].[dbo].[spGetGovernanceFinalizedCompanies] @ChangedSince

	SELECT * FROM @FinalizedCompanies
END
GO


